<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="generator" content="ApiGen 2.6.1" />
	<meta name="robots" content="noindex" />

	<title>File models/backend/notificacion/mnotificacion.php</title>

	<script type="text/javascript" src="resources/combined.js?144019575"></script>
	<script type="text/javascript" src="elementlist.js?2260620923"></script>
	<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?1532301413" />

</head>

<body>
<div id="left">
	<div id="menu">
		<a href="index.html" title="Overview"><span>Overview</span></a>


		<div id="groups">
			<h3>Packages</h3>
			<ul>
				<li><a href="package-CodeIgniter.html">CodeIgniter<span></span></a>
						<ul>
				<li><a href="package-CodeIgniter.Libraries.html">Libraries</a>
						</li>
							</ul></li>
				<li class="active"><a href="package-None.html">None</a>
						</li>
			</ul>
		</div>

		<hr />


		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li><a href="class-CargaMenu.html">CargaMenu</a></li>
				<li><a href="class-Configuracion.html">Configuracion</a></li>
				<li><a href="class-Cuenta.html">Cuenta</a></li>
				<li><a href="class-DatosPersonales.html">DatosPersonales</a></li>
				<li><a href="class-Deposito.html">Deposito</a></li>
				<li><a href="class-Format.html">Format</a></li>
				<li><a href="class-FPDF.html">FPDF</a></li>
				<li><a href="class-hacerTransferencia.html">hacerTransferencia</a></li>
				<li><a href="class-Hipoteca.html">Hipoteca</a></li>
				<li><a href="class-Home.html">Home</a></li>
				<li><a href="class-Inversiones.html">Inversiones</a></li>
				<li><a href="class-Login.html">Login</a></li>
				<li><a href="class-Macciones.html">Macciones</a></li>
				<li><a href="class-Mconfiguracion.html">Mconfiguracion</a></li>
				<li><a href="class-Mcuenta.html">Mcuenta</a></li>
				<li><a href="class-Mdatospersonales.html">Mdatospersonales</a></li>
				<li><a href="class-Mdeposito.html">Mdeposito</a></li>
				<li><a href="class-mHacerTransferencia.html">mHacerTransferencia</a></li>
				<li><a href="class-Minversion.html">Minversion</a></li>
				<li><a href="class-Mlogin.html">Mlogin</a></li>
				<li class="active"><a href="class-Mnotificacion.html">Mnotificacion</a></li>
				<li><a href="class-MobtenerListaValores.html">MobtenerListaValores</a></li>
				<li><a href="class-Mprestamo.html">Mprestamo</a></li>
				<li><a href="class-Mprincipal.html">Mprincipal</a></li>
				<li><a href="class-Msolicitud.html">Msolicitud</a></li>
				<li><a href="class-Mtarjeta.html">Mtarjeta</a></li>
				<li><a href="class-Musuarios.html">Musuarios</a></li>
				<li><a href="class-MY_Router.html">MY_Router</a></li>
				<li><a href="class-Notificacion.html">Notificacion</a></li>
				<li><a href="class-ObtenerListaValores.html">ObtenerListaValores</a></li>
				<li><a href="class-Prestamo.html">Prestamo</a></li>
				<li><a href="class-Principal.html">Principal</a></li>
				<li><a href="class-Solicitud.html">Solicitud</a></li>
				<li><a href="class-Tarjeta.html">Tarjeta</a></li>
				<li><a href="class-VerifyLogin.html">VerifyLogin</a></li>
			</ul>





		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form id="search">
		<input type="hidden" name="cx" value="" />
		<input type="hidden" name="ie" value="UTF-8" />
		<input type="text" name="q" class="text" />
		<input type="submit" value="Search" />
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
				<a href="package-None.html" title="Summary of None"><span>Package</span></a>
			</li>
			<li>
				<a href="class-Mnotificacion.html" title="Summary of Mnotificacion"><span>Class</span></a>
			</li>
		</ul>
		<ul>
			<li>
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
			</li>
		</ul>
		<ul>
		</ul>
	</div>

<pre><code><a href="#1" id="1" class="l"> 1: </a><span class="xlang">&lt;?php</span>
<a href="#2" id="2" class="l"> 2: </a>
<a href="#3" id="3" class="l"> 3: </a><span class="php-keyword1">Class</span> Mnotificacion <span class="php-keyword1">extends</span> CI_Model {
<a href="#4" id="4" class="l"> 4: </a>    
<a href="#5" id="5" class="l"> 5: </a>    <span class="php-comment">/**
</span><a href="#6" id="6" class="l"> 6: </a><span class="php-comment">     * Carga los datos de las notificaciones de un cliente y lo devuelve en forma de array de objetos.
</span><a href="#7" id="7" class="l"> 7: </a><span class="php-comment">     *
</span><a href="#8" id="8" class="l"> 8: </a><span class="php-comment">     * @param integer $idCliente
</span><a href="#9" id="9" class="l"> 9: </a><span class="php-comment">     * @return mixed
</span><a href="#10" id="10" class="l">10: </a><span class="php-comment">     */</span>
<a href="#11" id="11" class="l">11: </a>    <span class="php-keyword1">function</span> obtenerMensajes(<span class="php-var">$idCliente</span>) {
<a href="#12" id="12" class="l">12: </a>        <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">&quot;*&quot;</span>);
<a href="#13" id="13" class="l">13: </a>        <span class="php-var">$this</span>-&gt;db-&gt;from(<span class="php-quote">&quot;notificacion&quot;</span>);
<a href="#14" id="14" class="l">14: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">&quot;idCliente = &quot;</span> . <span class="php-var">$idCliente</span>);
<a href="#15" id="15" class="l">15: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">&quot;borrado = 0&quot;</span>);
<a href="#16" id="16" class="l">16: </a>        <span class="php-var">$this</span>-&gt;db-&gt;order_by(<span class="php-quote">&quot;fecha&quot;</span>, <span class="php-quote">&quot;desc&quot;</span>);
<a href="#17" id="17" class="l">17: </a>        <span class="php-var">$mensajes</span> = <span class="php-var">$this</span>-&gt;db-&gt;get();
<a href="#18" id="18" class="l">18: </a>        <span class="php-keyword1">return</span> <span class="php-var">$mensajes</span>-&gt;result();
<a href="#19" id="19" class="l">19: </a>    }
<a href="#20" id="20" class="l">20: </a>    
<a href="#21" id="21" class="l">21: </a>    <span class="php-comment">/**
</span><a href="#22" id="22" class="l">22: </a><span class="php-comment">     * Actualiza la BBDD modificando el estado de una notificacion a leido, y carga esa notificacion y lo devuelve en forma de array de objetos.
</span><a href="#23" id="23" class="l">23: </a><span class="php-comment">     *
</span><a href="#24" id="24" class="l">24: </a><span class="php-comment">     * @param integer $idNotificacion
</span><a href="#25" id="25" class="l">25: </a><span class="php-comment">     * @return mixed
</span><a href="#26" id="26" class="l">26: </a><span class="php-comment">     */</span>
<a href="#27" id="27" class="l">27: </a>    <span class="php-keyword1">function</span> leerNotificacion(<span class="php-var">$idNotificacion</span>) {
<a href="#28" id="28" class="l">28: </a>        <span class="php-var">$this</span>-&gt;db-&gt;query(<span class="php-quote">&quot;update notificacion set leido = 1 where id = &quot;</span> . <span class="php-var">$idNotificacion</span>);
<a href="#29" id="29" class="l">29: </a>        <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">'*'</span>);
<a href="#30" id="30" class="l">30: </a>        <span class="php-var">$this</span>-&gt;db-&gt;from(<span class="php-quote">'notificacion'</span>);
<a href="#31" id="31" class="l">31: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">'id = '</span> . <span class="php-var">$idNotificacion</span>);
<a href="#32" id="32" class="l">32: </a>        <span class="php-var">$notificacion</span> = <span class="php-var">$this</span>-&gt;db-&gt;get();
<a href="#33" id="33" class="l">33: </a>        <span class="php-keyword1">return</span> <span class="php-var">$notificacion</span>-&gt;result();
<a href="#34" id="34" class="l">34: </a>    }
<a href="#35" id="35" class="l">35: </a>
<a href="#36" id="36" class="l">36: </a>    <span class="php-comment">/**
</span><a href="#37" id="37" class="l">37: </a><span class="php-comment">     * Actualiza la BBDD eliminando una notificacion concreta.
</span><a href="#38" id="38" class="l">38: </a><span class="php-comment">     *
</span><a href="#39" id="39" class="l">39: </a><span class="php-comment">     * @param integer $idNotificacion
</span><a href="#40" id="40" class="l">40: </a><span class="php-comment">     */</span>
<a href="#41" id="41" class="l">41: </a>    <span class="php-keyword1">function</span> borrarNotificacion(<span class="php-var">$idNotificacion</span>) {
<a href="#42" id="42" class="l">42: </a>        <span class="php-var">$this</span>-&gt;db-&gt;query(<span class="php-quote">&quot;update notificacion set borrado = 1 where id = &quot;</span> . <span class="php-var">$idNotificacion</span>);
<a href="#43" id="43" class="l">43: </a>    }
<a href="#44" id="44" class="l">44: </a>    
<a href="#45" id="45" class="l">45: </a>    <span class="php-comment">/**
</span><a href="#46" id="46" class="l">46: </a><span class="php-comment">     * Recibe los datos necesarios para generar una notifiacion, y los inserta en la BBDD
</span><a href="#47" id="47" class="l">47: </a><span class="php-comment">     *
</span><a href="#48" id="48" class="l">48: </a><span class="php-comment">     * @param mixed $data
</span><a href="#49" id="49" class="l">49: </a><span class="php-comment">     */</span>
<a href="#50" id="50" class="l">50: </a>    <span class="php-keyword1">function</span> insertarNotificacion(<span class="php-var">$data</span>) {
<a href="#51" id="51" class="l">51: </a>        <span class="php-var">$sql</span> = <span class="php-quote">&quot;INSERT INTO notificacion (text, idCliente, asunto) VALUES ('&quot;</span> . <span class="php-var">$data</span>[<span class="php-quote">'text'</span>] . <span class="php-quote">&quot;', &quot;</span> . <span class="php-var">$data</span>[<span class="php-quote">'idCliente'</span>] . <span class="php-quote">&quot;, '&quot;</span> . <span class="php-var">$data</span>[<span class="php-quote">'asunto'</span>] . <span class="php-quote">&quot;')&quot;</span>;
<a href="#52" id="52" class="l">52: </a>        <span class="php-var">$this</span>-&gt;db-&gt;query(<span class="php-var">$sql</span>);
<a href="#53" id="53" class="l">53: </a>    }
<a href="#54" id="54" class="l">54: </a>    
<a href="#55" id="55" class="l">55: </a>    <span class="php-comment">/**
</span><a href="#56" id="56" class="l">56: </a><span class="php-comment">     * Carga la cantidad de mensajes sin leer de un cliente y lo devuelve en forma de array de objetos.
</span><a href="#57" id="57" class="l">57: </a><span class="php-comment">     *
</span><a href="#58" id="58" class="l">58: </a><span class="php-comment">     * @param integer $idCliente
</span><a href="#59" id="59" class="l">59: </a><span class="php-comment">     * @return mixed
</span><a href="#60" id="60" class="l">60: </a><span class="php-comment">     */</span>
<a href="#61" id="61" class="l">61: </a>    <span class="php-keyword1">function</span> cantidadNotificaciones(<span class="php-var">$idCliente</span>) {
<a href="#62" id="62" class="l">62: </a>        <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">'count(*) as cantidad'</span>, <span class="php-keyword1">false</span>);
<a href="#63" id="63" class="l">63: </a>        <span class="php-var">$this</span>-&gt;db-&gt;from(<span class="php-quote">'notificacion'</span>);
<a href="#64" id="64" class="l">64: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">'idCliente = '</span> . <span class="php-var">$idCliente</span>);
<a href="#65" id="65" class="l">65: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">'leido = 0'</span>);
<a href="#66" id="66" class="l">66: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">'borrado = 0'</span>);
<a href="#67" id="67" class="l">67: </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;db-&gt;get()-&gt;result();
<a href="#68" id="68" class="l">68: </a>    }
<a href="#69" id="69" class="l">69: </a>
<a href="#70" id="70" class="l">70: </a>}</code></pre>

	<div id="footer">
		 API documentation generated by <a href="http://apigen.org">ApiGen 2.6.1</a>
	</div>
</div>
</div>
</body>
</html>
